<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Analyze MySQL Database</title>
<style type="text/css">
body,td,th {
	font-family: Verdana, Geneva, sans-serif;
	font-size: 12px;
}
li { height:25px; }
.wrapper
{
	width:600px;
	margin:0px auto 0px auto;
}
.not-working { text-decoration:line-through; color:#F00; }
</style>
</head>
<body>
<div class="wrapper">
<p>
	<a href="analyze-mysql-columns.php">Analyze a MySQL database</a> - according to your configurations.
	<a href="source.php">View Source Code</a>
</p>
<h1>Pre-Analyzed Database Schema</h1>
<ol>
	<li>
		<a href="examples/4images1.7.11.txt">4Images 1.7.11</a> 
		| <a href="http://www.4homepages.de/4images/download.php">www.4homepages.de</a>
	</li>
	<li><a href="examples/anahita.txt">Anahita Version 2.0.6 over Joomla 1.5</a></li>
	<li>
		<a href="examples/collabtive.txt">Collabtive</a>
		| <a href="http://collabtive.o-dyn.de/">collabtive.o-dyn.de</a>
		| <a href="http://sourceforge.net/projects/collabtive/">Source Forge</a>
	</li>
	<li>
		<a href="examples/cmspro.txt">CMS Pro</a>
		| <a href="http://codecanyon.net/item/cms-pro-lightweight-content-management-system/140078">Buy</a>
		| <a href="http://codecanyon.net/item/cms-pro-lightweight-content-management-system/full_screen_preview/140078">Preview</a>
	</li>
	<li>
		<a href="examples/cphulkd.txt">cphulkd</a>
	</li>
	<li>
		<a href="examples/cpg_1.5.20.txt">Coppermine Photo Gallery</a>
		| <a href="http://coppermine-gallery.net/">coppermine-gallery.net</a>
		| <a href="http://space.dl.sourceforge.net/project/eenemeenemuu.u/cpg1.5.20.zip">cpg1.5.20.zip, 29 March 2012</a>
	<li>
		<a href="#" class="not-working">DotProject - Free Business & Enterprise software</a> 
		| <a href="http://sourceforge.net/projects/dotproject/">Source Forge</a>
	</li>
	<li>
		<a href="examples/eccube.txt">ECCube</a>
		| <a href="http://www.ec-cube.net/">www.ec-cube.net</a>
		| <a href="http://www.hiro-blog.com/2011/06/ec-cube-2-11以降のsmartyタグの違い一覧.html">Unofficial Blog</a>
	</li>
	<li>
		<a href="#" class="not-working">EndNote X6</a> 
		| <a href="http://www.endnote.com/">www.endnote.com</a> 
		| <a href="http://en.wikipedia.org/wiki/EndNote">wiki</a></li>
	<li>
		<a href="examples/eximstats.txt">eximstats</a>
	</li>
	<li>
		<a href="examples/horde.txt">Horde/cPanel</a>
		| <a href="http://www.horde.org/">www.horde.org</a>
		| <a href="http://www.horde.org/download/horde">Download</a>
	</li>
	<li>
		<a href="examples/joomla.txt">Joomla</a> 
		| <a href="http://www.joomla.org/">www.joomla.org</a>
	</li>
	<li><a href="examples/joomla_2.5.6.txt">Joomla 2.5.6 </a></li>
	<li>
		<a href="examples/joomla_3.0.0_beta1.txt">Joomla 3.0.0 Beta 1</a> 
		| <a href="http://downloads.joomlacode.org/frsrelease/7/5/9/75901/Joomla_3.0.0_beta1-Full_Package.tar.bz2">Download</a>
		| <a href="http://www.joomla.org/announcements/release-news/5460-joomla-3-0-beta1-released.html">Release, 06 September 2012</a>
	</li>
	<li>
		<a href="examples/magento-1.7.0.2.txt">Magento 1.7.0.2</a>
		| <a href="http://www.magentocommerce.com/">www.magentocommerce.com</a>
		| <a href="http://www.magentocommerce.com/getmagento/1.7.0.2/magento-1.7.0.2.tar.bz2">1.7.0.2.tar.bz2, July 5, 2012</a> 
		| <a href="http://www.magentocommerce.com/svn">SVN</a>
	</li>
	<li>
		<a href="examples/mantis.txt">Mantis 1.2.3 (2010)</a>
		| <a href="http://www.mantisbt.org/">www.mantisbt.org</a>
	</li>
	<li>
		<a href="examples/mantis_version1.2.11_schema_version183.txt">Mantis Version 1.2.11, Schema Version 183 (2012)</a>
		| <a href="http://space.dl.sourceforge.net/project/mantisbt/mantis-stable/1.2.11/mantisbt-1.2.11.zip">Download</a>
	</li>
	<li>
		<a href="examples/mysql.txt">MySQL 5.5.25a - Grants</a>
		| <a href="examples/information_schema.txt">MySQL 5.5.25a - Information Schema</a>
		| <a href="http://www.mysql.com/downloads/mysql/">Download</a>
	</li>
	<li>
		<a href="examples/opencart.txt">OpenCart Version 1.5.3</a>
		| <a href="http://www.opencart.com/">www.opencart.com</a>
		| <a href="https://github.com/opencart/opencart/downloads">Download</a>
		| <a href="http://www.opencart.com/index.php?route=download/download">Full list</a>
	</li>
	<li>
		<a href="examples/opencrypt.txt">OpenCrypt 1.8</a> 
		| <a href="http://www.opencrypt.com/">www.opencrypt.com</a>
		| <a href="http://www.opencrypt.com/purchase.php">Buy</a>
	</li>
	<li>
		<a href="examples/oscommerce-3.0.2.txt">osCommerce 3.0.2</a> 
		| <a href="http://www.oscommerce.com/">www.oscommerce.com</a>
		| <a href="http://www.oscommerce.com/solutions/downloads">Download</a>
		| <a href="http://www.oscommerce.com/files/oscommerce-3.0.2.zip">osCommerce 3.0.2</a>
	</li>
	<li>
		<a href="examples/phpbb3.txt">PHPBB 3</a> 
		| <a href="http://www.phpbb.com/files/release/phpBB-3.0.10.zip">Download phpBB-3.0.10.zip</a> 
		| <a href="http://www.phpbb.com/">www.phpbb.com</a>
	</li>
		<a href="examples/phpgedview-basic-4.2.4.txt">PhpGedView by PGV Development Team</a> 
		| <a href="http://kaz.dl.sourceforge.net/project/phpgedview/1%20PhpGedView/PhpGedView%20v4.2.4/PhpGedView-basic-4.2.4.zip">Download PhpGedView-basic-4.2.4.zip</a> 
		| <a href="http://sourceforge.net/projects/phpgedview/">SourceForge Project</a>
		| <a href="http://www.phpgedview.net/">www.phpgedview.net</a>
	<li>
		<a href="examples/phpmyadmin.txt">PHPMyAdmin</a>
		| <a href="http://www.phpmyadmin.net/home_page/index.php">www.phpmyadmin.net</a>
	</li>
	<li>
		<a href="examples/pixelpost.txt">PixelPost 1.7.3</a> | <a href="http://www.pixelpost.org/">www.pixelpost.org</a>
		| <a href="http://wiki.pixelpost.org/">Wiki</a>
		| <a href="http://forum.pixelpost.org">Forum</a>
	</li>
	<li>
		<a href="examples/prestashop-1.4.8.3.txt">PrestaShop 1.4.8.3</a> 
		| <a href="http://www.prestashop.com/">www.prestashop.com</a>
	</li> 
	<li>
		<a href="examples/redmine.txt">Red Mine</a>
		| <a href="http://www.redmine.org/">www.redmine.org</a>
	</li>
	<li>
		<a href="examples/roundcube.txt">Round Cube</a>
		| <a href="http://www.roundcube.net/">www.roundcube.net</a>
		| <a href="http://www.roundcube.net/download">Download</a>
	</li>
	<li>
		<a href="examples/seoboard.txt">SEO Board</a>
		| <a href="http://www.seo-board.com/">www.seo-board.com</a>
		| <a href="http://www.seo-board.com/seo-board110.zip">SEO Board 1.1.0</a>
	</li>
	<li>
		<a href="examples/supercali.txt">SuperCali 1.0.7</a>
		| <a href="http://supercali.inforest.com/">supercali.inforest.com</a>
		| <a href="http://supercali.inforest.com/downloads/supercali-1.0.7.tar.gz">Download</a>
		| <a href="http://supercali.inforest.com/demo_calendar/">Demo</a>
	</li>
	<li>
		<a href="#" class="not-working">Teamlab</a>
		| <a href="http://www.teamlab.com/">www.teamlab.com</a>
		| <a href="http://www.teamlab.com/blog/2010/07/step-by-step-guide-for-teamlab-open-source-deployment/">Deployment, migrate from SQLite database to MySQL</a>
	</li>
	<li>
		<a href="examples/timetrex.txt">Time Trex - Attendance, Payroll software</a>
		| <a href="http://www.timetrex.com/">www.timetrex.com</a>
	</li>
	<li><a href="examples/vtiger-crm.txt">vTiger CRM</a></li>
	<li>
		<a href="examples/wordpress.txt">Wordpress</a> 
		| <a href="examples/wordpress_3.4.2.txt">3.4.2</a> 
		| <a href="http://www.wordpress.org/">www.wordpress.org</a>
		| <a href="http://wordpress.org/latest.tar.gz">Download</a>
	</li>
	<li><a href="examples/zencart.txt">Zen Cart 1.3.9h</a></li>
	<li>
		<a href="examples/zen-cart-v150-full-release-12302011.txt">Zen Cart 1.50</a>
		| <a href="http://www.zen-cart.com/getit">Download</a>
		| <a href="http://sourceforge.net/projects/zencart/files/">Source Forge</a>
		| <a href="http://space.dl.sourceforge.net/project/zencart/CURRENT%20-%20Zen%20Cart%201.5.x%20Series/zen-cart-v150-full-release-12302011.zip">zen-cart-v150-full-release-12302011.zip</a>
	</li>
	<li>
		<a href="examples/zen-cart-v1.5.1-full-fileset-09182012.txt">Zen Cart 1.5.1</a>
		| <a href="http://www.zen-cart.com/getit">Download</a>
		| <a href="http://sourceforge.net/projects/zencart/files/">Source Forge</a>
		| <a href="http://nchc.dl.sourceforge.net/project/zencart/CURRENT%20-%20Zen%20Cart%201.5.x%20Series/zen-cart-v1.5.1-full-fileset-09182012.zip">zen-cart-v1.5.1-full-fileset-09182012.zip</a>
	</li>
</ol>
<h1>Skip List</h1>
<p><a href="skipped.php">Skipped columns</a></p>
<h1>What is this?</h1>
<p>Well, it is a collection of databases from various php/mysql based applications. It is aimed to help php/mysql developers know how the particular database is structured. It works by a standard column name being used within various tables within the database. For example, if you find that a colum name <em>editor</em> exists and is being used in the tables <em>jos_banner, jos_bannerclient, jos_categories</em> in Joomla Database.</p>
<p>This  script analyzes MySQL tables, columns and their relationships according to the similarity in column names. The output files are auto generated via the script.</p>
<p>Database works are done by the respective vendors of the applications.</p>
<p>It might contain database information of some paid software as well. There is no commercial intent or leaking sensitive information, behind this work/database reverse analysis.</p>
<p>Upon receiving a complain with convincing reason, I will remove the database here in the list.</p>
<h2>Developed by:</h2>
<p><a href="http://bimal.org.np/">Bimal Poudel</a></p>
</div>
</body>
</html>